SRDropExecution
METADATA
| Attribute | Value |
|---|---|
| Topic | 1450-away-drop |
| MLink Token | ClientTrading |
| Product | SRTrade |
| accessType | SELECT |
| MLink Endpoint | MLink-Order |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| dropNumber | BIGINT | PRI | 0 | SR drop record number |
| sysEnvironment | enum - SysEnvironment | 'None' | original source sys environment Stable Current etc | |
| runStatus | enum - RunStatus | 'None' | original source run status ProdBeta | |
| routingCode | TINYTEXT | '' | ||
| routingSeqNum | INT | 0 | ||
| secKey_at | enum - AssetType | 'None' | ||
| secKey_ts | enum - TickerSrc | 'None' | ||
| secKey_tk | VARCHAR(12) | '' | ||
| secKey_yr | SMALLINT UNSIGNED | 0 | ||
| secKey_mn | TINYINT UNSIGNED | 0 | ||
| secKey_dy | TINYINT UNSIGNED | 0 | ||
| secKey_xx | DOUBLE | 0 | ||
| secKey_cp | enum - CallPut | 'Call' | ||
| secType | enum - SpdrKeyType | 'None' | ||
| securityDesc | VARCHAR(16) | '' | ||
| securityType | VARCHAR(4) | '' | ||
| symbol | VARCHAR(12) | '' | symbol symbolSfx | |
| maturityDate | DATETIME(6) | '1900-01-01 00:00:00.000000' | ||
| strike | DOUBLE | 0 | ||
| callPut | enum - CallPut | 'Call' | ||
| account | TINYTEXT | '' | FixTag1 | |
| giveupFirm | VARCHAR(6) | '' | ||
| giveupAccnt | TINYTEXT | '' | ||
| clearingFirm | VARCHAR(6) | '' | ||
| clearingAccnt | TINYTEXT | '' | ||
| dropData1 | TINYTEXT | '' | ||
| dropData2 | TINYTEXT | '' | ||
| clOrdId | VARCHAR(32) | '' | child order clOrdId if available | |
| fillVersion | TINYINT UNSIGNED | 0 | cancelcorrect version number initial fill is version1 | |
| fillExecStatus | enum - ExecStatus | 'None' | SpiderRock execution status FillBustCorrectRejectSysRej | |
| fillDttm | DATETIME(6) | '1900-01-01 00:00:00.000000' | fill DateTime from SRDateTime | |
| fillQuantity | INT | 0 | fill size from execReportlastSize | |
| fillSide | enum - BuySell | 'None' | fill side from execReportside | |
| fillSSaleFlag | enum - ShortSaleFlag | 'None' | fill side from execReportside | |
| fillPositionType | enum - PositionType | 'None' | ||
| fillPrice | DOUBLE | 0 | fill price from execReportlastPrice | |
| fillTransactDttm | DATETIME(6) | '1900-01-01 00:00:00.000000' | fill DateTime from execReportfillDttm | |
| fillMarket | VARCHAR(8) | '' | fill market from execReportlastMarket | |
| fillSRLiqTag | VARCHAR(2) | '' | fill SR normalized liquidity tag | |
| fillExchLiqTag | VARCHAR(4) | '' | fill exchange liquidity code | |
| fillExchFee | FLOAT | 0 | fill exchange fee if available | |
| fillExecId | TINYTEXT | '' | fill execution id from execReportexecId | |
| fillRefExecId | TINYTEXT | '' | fill ref execution id from execReportrefExecId only set on a cancel or correct | |
| fillLegRefId | BIGINT | 0 | fill leg ref id from execReportlegRefId | |
| fillFirmType | VARCHAR(16) | '' | fill firm type as reported from street side | |
| fillExecBroker | VARCHAR(16) | '' | fill execution broker as reported from street side | |
| fillOrderCapacity | enum - OrderCapacity | 'None' | fill order capacity as reported from street side | |
| fillContraDetail | VARCHAR(16) | '' | fill contra party additional detail if available | |
| fillContraCapacity | enum - OrderCapacity | 'None' | fill order capacity of contra party if available | |
| fillStreetText | TINYTEXT | '' | ||
| netTimestamp | BIGINT | 0 | drop gateway arrival timestamp | |
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| dropNumber | 1 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRTrade`.`MsgSRDropExecution`
WHERE
/* Replace with a BIGINT */
`dropNumber` = 1234567890;
Doc Columns Query
SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SRDropExecution' ORDER BY ordinal_position ASC;